-
Re: Fill In A Cell
@Anthony DAmbrosio Create a second sheet that lists your codes and names. Then use INDEX/MATCH formula to determine the correct name from your second sheet.1 · -
Re: Parent Row to display Child Row value based on upcoming due date
Hey @Luke W. You're looking for the function combination of MIN and CHILDREN MIN displays the lowest number, or in this case the earliest date. CHILDREN indicates the subsequent rows in a hierarchy. …1 · -
Re: Is there a formula that allows to count rows from different sheets for one total?
Hi @Wen H. Yes! Just combine your CountIfs with a plus sign + like this... =COUNTIFS({Sheet 1 Range}, FIND(Model@row, @cell) > 0) + COUNTIFS({Sheet 2 Range}, FIND(Model@row, @cell) > 0) + COUNT…1 · -
Re: automatic email of completed form to submitter
Hey @eric.wong.compass You can add their email address field (type: contact) to the sheet/form (so they must enter it) and create an automation that sends an alert to them with their field data. I re…1 · -
Re: Formula Help with multiple conditions
Hi @otavilog Assuming your cross sheet references are setup correctly as {Color} and {Client}, you could use the formula below... =COUNTIFS({Client}, Client@row, {Color}, <>"") Does t…1 ·